Ebooks Patagonia Issues CSV MySQL Query, With Sub Queries

Overview

This document provides information about Ebooks Patagonia Issues CSV MySQL Query, With Sub Queries.

SELECT
 --  `issues`.tenant_id,
 --  `issues`.id,
 `issues`.external_id AS 'eISBN',
 `issues`.name,
 DATE(`issues`.created_at) AS 'Fecha de carga',
 (
  SELECT
   `name`
  FROM
   `tags`
   INNER JOIN `taggables` ON `tags`.`id` = `taggables`.`tag_id`
  WHERE
   `taggables`.`taggable_id` = issues.id
   AND `taggables`.`taggable_type` = 'issue'
   AND `tags`.`type` = 'category') AS 'Categoría',
 (
  SELECT
   `name`
  FROM
   `tags`
   INNER JOIN `taggables` ON `tags`.`id` = `taggables`.`tag_id`
  WHERE
   `taggables`.`taggable_id` = issues.id
   AND `taggables`.`taggable_type` = 'issue'
   AND `tags`.`type` = 'publisher') AS 'Editorial', IF((
   SELECT
    COUNT(*)
   FROM `favorites`
  WHERE
   favorites.issue_id = issues.id AND `favorites`.`user_id` = '166422'), 'si', '') AS 'Seleccionada'
  FROM
   `farfalla`.`issues`
  WHERE (`deleted_at` IS NULL) AND(`issues`.`tenant_id` = '1484')
ORDER BY
 `id` DESC;

---